Introduction

R Session Info

R version 3.3.2 (2016-10-31)
Platform: x86_64-apple-darwin13.4.0 (64-bit)
Running under: OS X Yosemite 10.10.5

locale:
[1] en_US.UTF-8/en_US.UTF-8/en_US.UTF-8/C/en_US.UTF-8/en_US.UTF-8

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] data.world_0.1.2 dplyr_0.5.0      plyr_1.8.4       readr_1.1.0     

loaded via a namespace (and not attached):
 [1] Rcpp_0.12.10    knitr_1.15.1    magrittr_1.5    hms_0.3         R6_2.2.0        stringr_1.1.0   httr_1.2.1      tools_3.3.2    
 [9] DBI_0.5-1       htmltools_0.3.5 yaml_2.1.14     lazyeval_0.2.0  assertthat_0.1  digest_0.6.11   rprojroot_1.1   tibble_1.3.0   
[17] base64enc_0.1-3 rsconnect_0.7   curl_2.3        evaluate_0.10   rmarkdown_1.3   stringi_1.1.2   backports_1.0.4 jsonlite_1.3   

Description

This notebook documents the education attainment levels and age-adjusted death rates (AADR) for different causes of death across the United States. The data has been organized to explore the relationship between education attainment and AAMR between 1999 and 2013.

Data

How to download dataset from Data.World:

  1. Log into your account on https://data.world/
  2. Under the Datasets tab, go to “S17 eDV Project 6”
  3. Scroll down until you reach “Death.csv”
  4. Click on download
  5. Save the file under a folder accessible by Tableau

ETL Script

Visualizations

Tableau

Barchart - AADR by State

Barchart displays the sum of the AADR per cause across the United States. Heart Disease and Cancer have consistently higher sums of AADR than the average AADR for all causes.

Barchart - AADR by Year

Barchart displays the sum of the AADR per cause from 1999-2013. The average sum of AADR for all causes do not vary greatly per year. Heart Disease, Cancer, and Stroke have consistently higher sums of AADR than the average AADR for all causes.

Bachelor’s Degree Attainment: Female

High Level

Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of female BS attainment (0.15-0.25). Compared to males, females also had a greater amount of states with high levels.

Low Level

Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of female BS attainment (<0.15).

Bachelor’s Degree Attainment: Male

High Level

Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of male BS attainment (0.15-0.25).

Low Level

Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of male BS attainment (<0.15).

Shiny

Barchart - AADR by State

Barchart displays the sum of the AADR per cause across the United States. Heart Disease and Cancer have consistently higher sums of AADR than the average AADR for all causes.

Barchart - AADR by Year

Barchart displays the sum of the AADR per cause from 1999-2013. The average sum of AADR for all causes do not vary greatly per year. Heart Disease, Cancer, and Stroke have consistently higher sums of AADR than the average AADR for all causes.

Bachelor’s Degree Attainment: Female

High Level

Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of female BS attainment (0.15-0.25). Compared to males, females also had a greater amount of states with high levels.

Low Level

Barchart displays females who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of female BS attainment (<0.15).

Bachelor’s Degree Attainment: Male

High Level

Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted high levels of male BS attainment (0.15-0.25).

Low Level

Barchart displays males who’ve attained a Bachelor’s Degree. The page only shows the set of states that hosted low levels of male BS attainment (<0.15).

LS0tCnRpdGxlOiAiQXNzb2NpYXRpb24gQmV0d2VlbiBBZ2UtQWRqdXN0ZWQgRGVhdGggUmF0ZSBhbmQgQmFjaGVsb3IncyBEZWdyZWUgQXR0YWlubWVudCIKYXV0aG9yOiAiTi4gSHVhLCBTLiBUcmFuLCBWLiBTaGFyYXRoLCBLLiBXYW5nIgpvdXRwdXQ6CiAgaHRtbF9kb2N1bWVudDoKICAgIHRvYzogeWVzCiAgaHRtbF9ub3RlYm9vazogZGVmYXVsdAogIHBkZl9kb2N1bWVudDogZGVmYXVsdAotLS0KIyAqKkludHJvZHVjdGlvbioqIAojIyMgKipSIFNlc3Npb24gSW5mbyoqCgpgYGB7ciBlY2hvPUZBTFNFfQpzZXNzaW9uSW5mbygpCmBgYAoKIyAqKkRlc2NyaXB0aW9uKioKVGhpcyBub3RlYm9vayBkb2N1bWVudHMgdGhlIGVkdWNhdGlvbiBhdHRhaW5tZW50IGxldmVscyBhbmQgYWdlLWFkanVzdGVkIGRlYXRoIHJhdGVzIChBQURSKSBmb3IgZGlmZmVyZW50IGNhdXNlcyBvZiBkZWF0aCBhY3Jvc3MgdGhlIFVuaXRlZCBTdGF0ZXMuIFRoZSBkYXRhIGhhcyBiZWVuIG9yZ2FuaXplZCB0byBleHBsb3JlIHRoZSByZWxhdGlvbnNoaXAgYmV0d2VlbiBlZHVjYXRpb24gYXR0YWlubWVudCBhbmQgQUFNUiBiZXR3ZWVuIDE5OTkgYW5kIDIwMTMuIAoKIyAqKkRhdGEqKgoqKkhvdyB0byBkb3dubG9hZCBkYXRhc2V0IGZyb20gRGF0YS5Xb3JsZDoqKgoKMS4gTG9nIGludG8geW91ciBhY2NvdW50IG9uIGh0dHBzOi8vZGF0YS53b3JsZC8KMi4gVW5kZXIgdGhlICpEYXRhc2V0cyogdGFiLCBnbyB0byAiUzE3IGVEViBQcm9qZWN0IDYiCjMuIFNjcm9sbCBkb3duIHVudGlsIHlvdSByZWFjaCAiRGVhdGguY3N2Igo0LiBDbGljayBvbiBkb3dubG9hZAo1LiBTYXZlIHRoZSBmaWxlIHVuZGVyIGEgZm9sZGVyIGFjY2Vzc2libGUgYnkgVGFibGVhdQoKIyAqKkVUTCBTY3JpcHQqKgpgYGAge3IgZWNobz1GQUxTRX0Kc291cmNlKCIuLi8wMSBEYXRhL0VUTF9TY3JpcHQuUiIpCmBgYAoKIyAqKlZpc3VhbGl6YXRpb25zKioKCiMjICoqVGFibGVhdSoqCgojIyMgKipCYXJjaGFydCAtIEFBRFIgYnkgU3RhdGUqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvQmFyY2hhcnRfQUFEUi5wbmcpPC9jZW50ZXI+CkJhcmNoYXJ0IGRpc3BsYXlzIHRoZSBzdW0gb2YgdGhlIEFBRFIgcGVyIGNhdXNlIGFjcm9zcyB0aGUgVW5pdGVkIFN0YXRlcy4KSGVhcnQgRGlzZWFzZSBhbmQgQ2FuY2VyIGhhdmUgY29uc2lzdGVudGx5IGhpZ2hlciBzdW1zIG9mIEFBRFIgdGhhbiB0aGUgYXZlcmFnZSBBQURSIGZvciBhbGwgY2F1c2VzLiAgCgoKIyMjICoqQmFyY2hhcnQgLSBBQURSIGJ5IFllYXIqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvWXItU3VtRGVhdGgtRGlmZi5wbmcpPC9jZW50ZXI+CkJhcmNoYXJ0IGRpc3BsYXlzIHRoZSBzdW0gb2YgdGhlIEFBRFIgcGVyIGNhdXNlIGZyb20gMTk5OS0yMDEzLiAKVGhlIGF2ZXJhZ2Ugc3VtIG9mIEFBRFIgZm9yIGFsbCBjYXVzZXMgZG8gbm90IHZhcnkgZ3JlYXRseSBwZXIgeWVhci4KSGVhcnQgRGlzZWFzZSwgQ2FuY2VyLCBhbmQgU3Ryb2tlIGhhdmUgY29uc2lzdGVudGx5IGhpZ2hlciBzdW1zIG9mIEFBRFIgdGhhbiB0aGUgYXZlcmFnZSBBQURSIGZvciBhbGwgY2F1c2VzLiAgCgojIyMgKipCYWNoZWxvcidzIERlZ3JlZSBBdHRhaW5tZW50OiBGZW1hbGUqKgoKKipIaWdoIExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0ZfSGlnaF9CUy5wbmcpPC9jZW50ZXI+CkJhcmNoYXJ0IGRpc3BsYXlzIGZlbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGhpZ2ggbGV2ZWxzIG9mIGZlbWFsZSBCUyBhdHRhaW5tZW50ICgwLjE1LTAuMjUpLgpDb21wYXJlZCB0byBtYWxlcywgZmVtYWxlcyBhbHNvIGhhZCBhIGdyZWF0ZXIgYW1vdW50IG9mIHN0YXRlcyB3aXRoIGhpZ2ggbGV2ZWxzLiAKCioqTG93IExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL0ZfTG93X0JTLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIGZlbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGxvdyBsZXZlbHMgb2YgZmVtYWxlIEJTIGF0dGFpbm1lbnQgKDwwLjE1KS4KCiMjIyAqKkJhY2hlbG9yJ3MgRGVncmVlIEF0dGFpbm1lbnQ6IE1hbGUqKgoKKipIaWdoIExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL01fSGlnaF9CUy5wbmcpPC9jZW50ZXI+IApCYXJjaGFydCBkaXNwbGF5cyBtYWxlcyB3aG8ndmUgYXR0YWluZWQgYSBCYWNoZWxvcidzIERlZ3JlZS4gClRoZSBwYWdlIG9ubHkgc2hvd3MgdGhlIHNldCBvZiBzdGF0ZXMgdGhhdCBob3N0ZWQgaGlnaCBsZXZlbHMgb2YgbWFsZSBCUyBhdHRhaW5tZW50ICgwLjE1LTAuMjUpLgoKKipMb3cgTGV2ZWwqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvTV9Mb3dfQlMucG5nKTwvY2VudGVyPiAKQmFyY2hhcnQgZGlzcGxheXMgbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGxvdyBsZXZlbHMgb2YgbWFsZSBCUyBhdHRhaW5tZW50ICg8MC4xNSkuCgoKIyMgKipTaGlueSoqCiMjIyMgKipQdWJsaXNoZWQgU2hpbnkgYXBwIGxpbmsqKgpodHRwczovL3N0ZXZlbnRyYW4uc2hpbnlhcHBzLmlvL3Byb2plY3Q2X3NoaW55LwoKIyMjICoqQmFyY2hhcnQgLSBBQURSIGJ5IFN0YXRlKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL3NoaW55X3N0YXRlX2FhZHIucG5nKTwvY2VudGVyPiAKQmFyY2hhcnQgZGlzcGxheXMgdGhlIHN1bSBvZiB0aGUgQUFEUiBwZXIgY2F1c2UgYWNyb3NzIHRoZSBVbml0ZWQgU3RhdGVzLgpIZWFydCBEaXNlYXNlIGFuZCBDYW5jZXIgaGF2ZSBjb25zaXN0ZW50bHkgaGlnaGVyIHN1bXMgb2YgQUFEUiB0aGFuIHRoZSBhdmVyYWdlIEFBRFIgZm9yIGFsbCBjYXVzZXMuICAKCiMjIyAqKkJhcmNoYXJ0IC0gQUFEUiBieSBZZWFyKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL3NoaW55X3lyX2FhZHIucG5nKTwvY2VudGVyPiAKQmFyY2hhcnQgZGlzcGxheXMgdGhlIHN1bSBvZiB0aGUgQUFEUiBwZXIgY2F1c2UgZnJvbSAxOTk5LTIwMTMuIApUaGUgYXZlcmFnZSBzdW0gb2YgQUFEUiBmb3IgYWxsIGNhdXNlcyBkbyBub3QgdmFyeSBncmVhdGx5IHBlciB5ZWFyLgpIZWFydCBEaXNlYXNlLCBDYW5jZXIsIGFuZCBTdHJva2UgaGF2ZSBjb25zaXN0ZW50bHkgaGlnaGVyIHN1bXMgb2YgQUFEUiB0aGFuIHRoZSBhdmVyYWdlIEFBRFIgZm9yIGFsbCBjYXVzZXMuICAKCiMjIyAqKkJhY2hlbG9yJ3MgRGVncmVlIEF0dGFpbm1lbnQ6IEZlbWFsZSoqCgoqKkhpZ2ggTGV2ZWwqKgohW10oLi4vMDMgVmlzdWFsaXphdGlvbnMvc2hpbnlfaGlnaF9mYnMucG5nKTwvY2VudGVyPgpCYXJjaGFydCBkaXNwbGF5cyBmZW1hbGVzIHdobyd2ZSBhdHRhaW5lZCBhIEJhY2hlbG9yJ3MgRGVncmVlLiAKVGhlIHBhZ2Ugb25seSBzaG93cyB0aGUgc2V0IG9mIHN0YXRlcyB0aGF0IGhvc3RlZCBoaWdoIGxldmVscyBvZiBmZW1hbGUgQlMgYXR0YWlubWVudCAoMC4xNS0wLjI1KS4KQ29tcGFyZWQgdG8gbWFsZXMsIGZlbWFsZXMgYWxzbyBoYWQgYSBncmVhdGVyIGFtb3VudCBvZiBzdGF0ZXMgd2l0aCBoaWdoIGxldmVscy4gCgoqKkxvdyBMZXZlbCoqCiFbXSguLi8wMyBWaXN1YWxpemF0aW9ucy9zaGlueV9sb3dfZmJzLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIGZlbWFsZXMgd2hvJ3ZlIGF0dGFpbmVkIGEgQmFjaGVsb3IncyBEZWdyZWUuIApUaGUgcGFnZSBvbmx5IHNob3dzIHRoZSBzZXQgb2Ygc3RhdGVzIHRoYXQgaG9zdGVkIGxvdyBsZXZlbHMgb2YgZmVtYWxlIEJTIGF0dGFpbm1lbnQgKDwwLjE1KS4KCiMjIyAqKkJhY2hlbG9yJ3MgRGVncmVlIEF0dGFpbm1lbnQ6IE1hbGUqKgoKKipIaWdoIExldmVsKioKIVtdKC4uLzAzIFZpc3VhbGl6YXRpb25zL3NoaW55X2hpZ2hfbWJzLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIG1hbGVzIHdobyd2ZSBhdHRhaW5lZCBhIEJhY2hlbG9yJ3MgRGVncmVlLiAKVGhlIHBhZ2Ugb25seSBzaG93cyB0aGUgc2V0IG9mIHN0YXRlcyB0aGF0IGhvc3RlZCBoaWdoIGxldmVscyBvZiBtYWxlIEJTIGF0dGFpbm1lbnQgKDAuMTUtMC4yNSkuCgoqKkxvdyBMZXZlbCoqCiFbXSguLi8wMyBWaXN1YWxpemF0aW9ucy9zaGlueV9sb3dfbWJzLnBuZyk8L2NlbnRlcj4gCkJhcmNoYXJ0IGRpc3BsYXlzIG1hbGVzIHdobyd2ZSBhdHRhaW5lZCBhIEJhY2hlbG9yJ3MgRGVncmVlLiAKVGhlIHBhZ2Ugb25seSBzaG93cyB0aGUgc2V0IG9mIHN0YXRlcyB0aGF0IGhvc3RlZCBsb3cgbGV2ZWxzIG9mIG1hbGUgQlMgYXR0YWlubWVudCAoPDAuMTUpLgoKIyAqKlNoaW55IExpbmsqKgpodHRwczovL3N0ZXZlbnRyYW4uc2hpbnlhcHBzLmlvL3Byb2plY3Q2X3NoaW55LwoK